﻿--
CREATE Proc [dbo].[proc_Employee_Department_Check]
(
	@UserName nvarchar(50)
)
as
	Begin
		Declare	@DepartmentId int
		Select @DepartmentId=DepartmentId From Employee Where UserName=@UserName
		Select * From Employee_Department Where DepartmentId=@DepartmentId
	End